﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SASDataSet" targetNamespace="http://tempuri.org/SASDataSet.xsd" xmlns:mstns="http://tempuri.org/SASDataSet.xsd" xmlns="http://tempuri.org/SASDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SASConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SASConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.StudentManagement.Properties.Settings.GlobalReference.Default.SASConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="loginTableAdapter" GeneratorDataComponentClassName="loginTableAdapter" Name="login" UserDataComponentName="loginTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SASConnectionString (Settings)" DbObjectName="SAS.dbo.login" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[login] WHERE (([username] = @Original_username) AND ([password] = @Original_password))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[login] ([username], [password]) VALUES (@username, @password);
SELECT username, password FROM dbo.login WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT username, password FROM dbo.login</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[login] SET [username] = @username, [password] = @password WHERE (([username] = @Original_username) AND ([password] = @Original_password));
SELECT username, password FROM dbo.login WHERE (username = @username)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StudentsInfoTableAdapter" GeneratorDataComponentClassName="StudentsInfoTableAdapter" Name="StudentsInfo" UserDataComponentName="StudentsInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SASConnectionString (Settings)" DbObjectName="SAS.dbo.StudentsInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[StudentsInfo] WHERE (([EGN] = @Original_EGN) AND ([AuthNumber] = @Original_AuthNumber) AND ([Class] = @Original_Class) AND ([NumberInClass] = @Original_NumberInClass) AND ([FirstName] = @Original_FirstName) AND ([SecondName] = @Original_SecondName) AND ([LastName] = @Original_LastName) AND ([Country] = @Original_Country) AND ([City] = @Original_City) AND ([ZipCode] = @Original_ZipCode) AND ((@IsNull_HomePhone = 1 AND [HomePhone] IS NULL) OR ([HomePhone] = @Original_HomePhone)) AND ([CellPhone] = @Original_CellPhone) AND ((@IsNull_GuardianCellPhone = 1 AND [GuardianCellPhone] IS NULL) OR ([GuardianCellPhone] = @Original_GuardianCellPhone)) AND ((@IsNull_MotherCellPhone = 1 AND [MotherCellPhone] IS NULL) OR ([MotherCellPhone] = @Original_MotherCellPhone)) AND ((@IsNull_FatherCellPhone = 1 AND [FatherCellPhone] IS NULL) OR ([FatherCellPhone] = @Original_FatherCellPhone)) AND ((@IsNull_GPName = 1 AND [GPName] IS NULL) OR ([GPName] = @Original_GPName)) AND ([GPCellPhone] = @Original_GPCellPhone))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_EGN" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="EGN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_AuthNumber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="AuthNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_NumberInClass" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="NumberInClass" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SecondName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SecondName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HomePhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HomePhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HomePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HomePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GuardianCellPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GuardianCellPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GuardianCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GuardianCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MotherCellPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MotherCellPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MotherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotherCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FatherCellPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FatherCellPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FatherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FatherCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GPName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GPName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GPName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GPCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[StudentsInfo] ([EGN], [AuthNumber], [Class], [NumberInClass], [FirstName], [SecondName], [LastName], [Specialty], [ExActivities], [Country], [City], [ZipCode], [Adress], [HomePhone], [CellPhone], [GuardianName], [GuardianCellPhone], [MotherName], [MotherCellPhone], [FatherName], [FatherCellPhone], [GPName], [GPCellPhone], [Notes], [StudentImage]) VALUES (@EGN, @AuthNumber, @Class, @NumberInClass, @FirstName, @SecondName, @LastName, @Specialty, @ExActivities, @Country, @City, @ZipCode, @Adress, @HomePhone, @CellPhone, @GuardianName, @GuardianCellPhone, @MotherName, @MotherCellPhone, @FatherName, @FatherCellPhone, @GPName, @GPCellPhone, @Notes, @StudentImage);
SELECT EGN, AuthNumber, Class, NumberInClass, FirstName, SecondName, LastName, Specialty, ExActivities, Country, City, ZipCode, Adress, HomePhone, CellPhone, GuardianName, GuardianCellPhone, MotherName, MotherCellPhone, FatherName, FatherCellPhone, GPName, GPCellPhone, Notes, StudentImage FROM dbo.StudentsInfo WHERE (EGN = @EGN)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@EGN" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="EGN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@AuthNumber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="AuthNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@NumberInClass" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="NumberInClass" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SecondName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SecondName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Specialty" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Specialty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ExActivities" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="ExActivities" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adress" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Adress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HomePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HomePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GuardianName" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="GuardianName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GuardianCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GuardianCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotherName" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="MotherName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotherCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FatherName" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="FatherName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FatherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FatherCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GPName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GPCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@StudentImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="StudentImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EGN, AuthNumber, Class, NumberInClass, FirstName, SecondName, LastName, Specialty, ExActivities, Country, City, ZipCode, Adress, HomePhone, CellPhone, GuardianName, GuardianCellPhone, MotherName, MotherCellPhone, FatherName, FatherCellPhone, GPName, GPCellPhone, Notes, StudentImage FROM dbo.StudentsInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[StudentsInfo] SET [EGN] = @EGN, [AuthNumber] = @AuthNumber, [Class] = @Class, [NumberInClass] = @NumberInClass, [FirstName] = @FirstName, [SecondName] = @SecondName, [LastName] = @LastName, [Specialty] = @Specialty, [ExActivities] = @ExActivities, [Country] = @Country, [City] = @City, [ZipCode] = @ZipCode, [Adress] = @Adress, [HomePhone] = @HomePhone, [CellPhone] = @CellPhone, [GuardianName] = @GuardianName, [GuardianCellPhone] = @GuardianCellPhone, [MotherName] = @MotherName, [MotherCellPhone] = @MotherCellPhone, [FatherName] = @FatherName, [FatherCellPhone] = @FatherCellPhone, [GPName] = @GPName, [GPCellPhone] = @GPCellPhone, [Notes] = @Notes, [StudentImage] = @StudentImage WHERE (([EGN] = @Original_EGN) AND ([AuthNumber] = @Original_AuthNumber) AND ([Class] = @Original_Class) AND ([NumberInClass] = @Original_NumberInClass) AND ([FirstName] = @Original_FirstName) AND ([SecondName] = @Original_SecondName) AND ([LastName] = @Original_LastName) AND ([Country] = @Original_Country) AND ([City] = @Original_City) AND ([ZipCode] = @Original_ZipCode) AND ((@IsNull_HomePhone = 1 AND [HomePhone] IS NULL) OR ([HomePhone] = @Original_HomePhone)) AND ([CellPhone] = @Original_CellPhone) AND ((@IsNull_GuardianCellPhone = 1 AND [GuardianCellPhone] IS NULL) OR ([GuardianCellPhone] = @Original_GuardianCellPhone)) AND ((@IsNull_MotherCellPhone = 1 AND [MotherCellPhone] IS NULL) OR ([MotherCellPhone] = @Original_MotherCellPhone)) AND ((@IsNull_FatherCellPhone = 1 AND [FatherCellPhone] IS NULL) OR ([FatherCellPhone] = @Original_FatherCellPhone)) AND ((@IsNull_GPName = 1 AND [GPName] IS NULL) OR ([GPName] = @Original_GPName)) AND ([GPCellPhone] = @Original_GPCellPhone));
SELECT EGN, AuthNumber, Class, NumberInClass, FirstName, SecondName, LastName, Specialty, ExActivities, Country, City, ZipCode, Adress, HomePhone, CellPhone, GuardianName, GuardianCellPhone, MotherName, MotherCellPhone, FatherName, FatherCellPhone, GPName, GPCellPhone, Notes, StudentImage FROM dbo.StudentsInfo WHERE (EGN = @EGN)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@EGN" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="EGN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@AuthNumber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="AuthNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Class" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@NumberInClass" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="NumberInClass" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SecondName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SecondName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Specialty" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Specialty" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ExActivities" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="ExActivities" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adress" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Adress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HomePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HomePhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GuardianName" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="GuardianName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GuardianCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GuardianCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotherName" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="MotherName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotherCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FatherName" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="FatherName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FatherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FatherCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GPName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@GPCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPCellPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@StudentImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="StudentImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_EGN" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="EGN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_AuthNumber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="AuthNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Class" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Class" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_NumberInClass" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="NumberInClass" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FirstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SecondName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SecondName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_LastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="LastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Country" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ZipCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HomePhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HomePhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HomePhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HomePhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GuardianCellPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GuardianCellPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GuardianCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GuardianCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MotherCellPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MotherCellPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MotherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotherCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FatherCellPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FatherCellPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FatherCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FatherCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GPName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GPName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GPName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_GPCellPhone" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="GPCellPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EGN" DataSetColumn="EGN" />
              <Mapping SourceColumn="AuthNumber" DataSetColumn="AuthNumber" />
              <Mapping SourceColumn="Class" DataSetColumn="Class" />
              <Mapping SourceColumn="NumberInClass" DataSetColumn="NumberInClass" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="SecondName" DataSetColumn="SecondName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="Specialty" DataSetColumn="Specialty" />
              <Mapping SourceColumn="ExActivities" DataSetColumn="ExActivities" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
              <Mapping SourceColumn="Adress" DataSetColumn="Adress" />
              <Mapping SourceColumn="HomePhone" DataSetColumn="HomePhone" />
              <Mapping SourceColumn="CellPhone" DataSetColumn="CellPhone" />
              <Mapping SourceColumn="GuardianName" DataSetColumn="GuardianName" />
              <Mapping SourceColumn="GuardianCellPhone" DataSetColumn="GuardianCellPhone" />
              <Mapping SourceColumn="MotherName" DataSetColumn="MotherName" />
              <Mapping SourceColumn="MotherCellPhone" DataSetColumn="MotherCellPhone" />
              <Mapping SourceColumn="FatherName" DataSetColumn="FatherName" />
              <Mapping SourceColumn="FatherCellPhone" DataSetColumn="FatherCellPhone" />
              <Mapping SourceColumn="GPName" DataSetColumn="GPName" />
              <Mapping SourceColumn="GPCellPhone" DataSetColumn="GPCellPhone" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="StudentImage" DataSetColumn="StudentImage" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SASDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SASDataSet" msprop:Generator_UserDSName="SASDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="login" msprop:Generator_TableClassName="loginDataTable" msprop:Generator_TableVarName="tablelogin" msprop:Generator_TablePropName="login" msprop:Generator_RowDeletingName="loginRowDeleting" msprop:Generator_UserTableName="login" msprop:Generator_RowChangingName="loginRowChanging" msprop:Generator_RowEvHandlerName="loginRowChangeEventHandler" msprop:Generator_RowDeletedName="loginRowDeleted" msprop:Generator_RowEvArgName="loginRowChangeEvent" msprop:Generator_RowChangedName="loginRowChanged" msprop:Generator_RowClassName="loginRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StudentsInfo" msprop:Generator_TableClassName="StudentsInfoDataTable" msprop:Generator_TableVarName="tableStudentsInfo" msprop:Generator_TablePropName="StudentsInfo" msprop:Generator_RowDeletingName="StudentsInfoRowDeleting" msprop:Generator_UserTableName="StudentsInfo" msprop:Generator_RowChangingName="StudentsInfoRowChanging" msprop:Generator_RowEvHandlerName="StudentsInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="StudentsInfoRowDeleted" msprop:Generator_RowEvArgName="StudentsInfoRowChangeEvent" msprop:Generator_RowChangedName="StudentsInfoRowChanged" msprop:Generator_RowClassName="StudentsInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EGN" msprop:Generator_ColumnVarNameInTable="columnEGN" msprop:Generator_ColumnPropNameInRow="EGN" msprop:Generator_ColumnPropNameInTable="EGNColumn" msprop:Generator_UserColumnName="EGN" type="xs:long" />
              <xs:element name="AuthNumber" msprop:Generator_ColumnVarNameInTable="columnAuthNumber" msprop:Generator_ColumnPropNameInRow="AuthNumber" msprop:Generator_ColumnPropNameInTable="AuthNumberColumn" msprop:Generator_UserColumnName="AuthNumber" type="xs:long" />
              <xs:element name="Class" msprop:Generator_ColumnVarNameInTable="columnClass" msprop:Generator_ColumnPropNameInRow="Class" msprop:Generator_ColumnPropNameInTable="ClassColumn" msprop:Generator_UserColumnName="Class">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumberInClass" msprop:Generator_ColumnVarNameInTable="columnNumberInClass" msprop:Generator_ColumnPropNameInRow="NumberInClass" msprop:Generator_ColumnPropNameInTable="NumberInClassColumn" msprop:Generator_UserColumnName="NumberInClass" type="xs:unsignedByte" />
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SecondName" msprop:Generator_ColumnVarNameInTable="columnSecondName" msprop:Generator_ColumnPropNameInRow="SecondName" msprop:Generator_ColumnPropNameInTable="SecondNameColumn" msprop:Generator_UserColumnName="SecondName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Specialty" msprop:Generator_ColumnVarNameInTable="columnSpecialty" msprop:Generator_ColumnPropNameInRow="Specialty" msprop:Generator_ColumnPropNameInTable="SpecialtyColumn" msprop:Generator_UserColumnName="Specialty">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExActivities" msprop:Generator_ColumnVarNameInTable="columnExActivities" msprop:Generator_ColumnPropNameInRow="ExActivities" msprop:Generator_ColumnPropNameInTable="ExActivitiesColumn" msprop:Generator_UserColumnName="ExActivities" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZipCode" msprop:Generator_ColumnVarNameInTable="columnZipCode" msprop:Generator_ColumnPropNameInRow="ZipCode" msprop:Generator_ColumnPropNameInTable="ZipCodeColumn" msprop:Generator_UserColumnName="ZipCode" type="xs:int" />
              <xs:element name="Adress" msprop:Generator_ColumnVarNameInTable="columnAdress" msprop:Generator_ColumnPropNameInRow="Adress" msprop:Generator_ColumnPropNameInTable="AdressColumn" msprop:Generator_UserColumnName="Adress">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HomePhone" msprop:Generator_ColumnVarNameInTable="columnHomePhone" msprop:Generator_ColumnPropNameInRow="HomePhone" msprop:Generator_ColumnPropNameInTable="HomePhoneColumn" msprop:Generator_UserColumnName="HomePhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CellPhone" msprop:Generator_ColumnVarNameInTable="columnCellPhone" msprop:Generator_ColumnPropNameInRow="CellPhone" msprop:Generator_ColumnPropNameInTable="CellPhoneColumn" msprop:Generator_UserColumnName="CellPhone">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GuardianName" msprop:Generator_ColumnVarNameInTable="columnGuardianName" msprop:Generator_ColumnPropNameInRow="GuardianName" msprop:Generator_ColumnPropNameInTable="GuardianNameColumn" msprop:Generator_UserColumnName="GuardianName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GuardianCellPhone" msprop:Generator_ColumnVarNameInTable="columnGuardianCellPhone" msprop:Generator_ColumnPropNameInRow="GuardianCellPhone" msprop:Generator_ColumnPropNameInTable="GuardianCellPhoneColumn" msprop:Generator_UserColumnName="GuardianCellPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MotherName" msprop:Generator_ColumnVarNameInTable="columnMotherName" msprop:Generator_ColumnPropNameInRow="MotherName" msprop:Generator_ColumnPropNameInTable="MotherNameColumn" msprop:Generator_UserColumnName="MotherName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MotherCellPhone" msprop:Generator_ColumnVarNameInTable="columnMotherCellPhone" msprop:Generator_ColumnPropNameInRow="MotherCellPhone" msprop:Generator_ColumnPropNameInTable="MotherCellPhoneColumn" msprop:Generator_UserColumnName="MotherCellPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FatherName" msprop:Generator_ColumnVarNameInTable="columnFatherName" msprop:Generator_ColumnPropNameInRow="FatherName" msprop:Generator_ColumnPropNameInTable="FatherNameColumn" msprop:Generator_UserColumnName="FatherName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FatherCellPhone" msprop:Generator_ColumnVarNameInTable="columnFatherCellPhone" msprop:Generator_ColumnPropNameInRow="FatherCellPhone" msprop:Generator_ColumnPropNameInTable="FatherCellPhoneColumn" msprop:Generator_UserColumnName="FatherCellPhone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GPName" msprop:Generator_ColumnVarNameInTable="columnGPName" msprop:Generator_ColumnPropNameInRow="GPName" msprop:Generator_ColumnPropNameInTable="GPNameColumn" msprop:Generator_UserColumnName="GPName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GPCellPhone" msprop:Generator_ColumnVarNameInTable="columnGPCellPhone" msprop:Generator_ColumnPropNameInRow="GPCellPhone" msprop:Generator_ColumnPropNameInTable="GPCellPhoneColumn" msprop:Generator_UserColumnName="GPCellPhone">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnPropNameInTable="NotesColumn" msprop:Generator_UserColumnName="Notes">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StudentImage" msprop:Generator_ColumnVarNameInTable="columnStudentImage" msprop:Generator_ColumnPropNameInRow="StudentImage" msprop:Generator_ColumnPropNameInTable="StudentImageColumn" msprop:Generator_UserColumnName="StudentImage" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:login" />
      <xs:field xpath="mstns:username" />
    </xs:unique>
    <xs:unique name="StudentsInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StudentsInfo" />
      <xs:field xpath="mstns:EGN" />
    </xs:unique>
  </xs:element>
</xs:schema>